Overview

Dataset statistics

Number of variables	28
Number of observations	507
Missing cells	6062
Missing cells (%)	42.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	98.2 KiB
Average record size in memory	198.3 B

Variable types

Categorical	12
Numeric	5
Unsupported	4
Text	5
Boolean	2

Alerts

`HEAD_OFFICE_ID` has constant value "2"	Constant
`REC_TYPE` has constant value "U"	Constant
`CIN_EXT_SALES_ID` has constant value ""	Constant
`CRNCY_ID` has constant value "1.0"	Constant
`CIN_CRNCY` has constant value "1"	Constant
`CIN_CRCY_REG` has constant value ""	Constant
`CIN_EMAIL` has constant value ""	Constant
`CIN_IS_DEL` has constant value "False"	Constant
`CCT_ID` is highly overall correlated with `CIN_ACCT_CODE` and 3 other fields	High correlation
`CIN_ACCT_CODE` is highly overall correlated with `CCT_ID` and 2 other fields	High correlation
`CIN_GL_CODE` is highly overall correlated with `CCT_ID` and 2 other fields	High correlation
`CIN_GST_CODE` is highly overall correlated with `SRC_DB_ID` and 1 other fields	High correlation
`CIN_ID` is highly overall correlated with `SRC_DB_ID` and 1 other fields	High correlation
`CIN_IS_ACTV` is highly overall correlated with `CIN_STATUS_CODE` and 2 other fields	High correlation
`CIN_STATUS_CODE` is highly overall correlated with `CIN_IS_ACTV` and 2 other fields	High correlation
`CIN_TYPE_ID` is highly overall correlated with `CIN_GL_CODE` and 1 other fields	High correlation
`SITE_ID` is highly overall correlated with `SRC_TYPE_ID`	High correlation
`SRC_DB_ID` is highly overall correlated with `CCT_ID` and 6 other fields	High correlation
`SRC_TYPE_ID` is highly overall correlated with `CCT_ID` and 9 other fields	High correlation
`CIN_STATUS_CODE` is highly imbalanced (52.0%)	Imbalance
`CCT_ID` is highly imbalanced (65.5%)	Imbalance
`CIN_ACCT_CODE` is highly imbalanced (76.1%)	Imbalance
`REC_TYPE` has 280 (55.2%) missing values	Missing
`CIN_EXT_SALES_ID` has 227 (44.8%) missing values	Missing
`CIN_GRP_ID` has 507 (100.0%) missing values	Missing
`CIN_STATUS_CODE` has 227 (44.8%) missing values	Missing
`CIN_TYPE_ID` has 227 (44.8%) missing values	Missing
`CCT_ID` has 227 (44.8%) missing values	Missing
`CRNCY_ID` has 227 (44.8%) missing values	Missing
`SITE_ID` has 227 (44.8%) missing values	Missing
`CINEMA` has 227 (44.8%) missing values	Missing
`CIN_ACCT_CODE` has 227 (44.8%) missing values	Missing
`CIN_CODE` has 6 (1.2%) missing values	Missing
`CIN_CRNCY` has 227 (44.8%) missing values	Missing
`CIN_CRCY_REG` has 227 (44.8%) missing values	Missing
`CIN_EMAIL` has 363 (71.6%) missing values	Missing
`CIN_GL_CODE` has 227 (44.8%) missing values	Missing
`CIN_GRP_CODE` has 507 (100.0%) missing values	Missing
`CIN_GST_CODE` has 227 (44.8%) missing values	Missing
`CIN_HO_CODE` has 102 (20.1%) missing values	Missing
`CIN_IS_ACTV` has 166 (32.7%) missing values	Missing
`CIN_IS_DEL` has 166 (32.7%) missing values	Missing
`CIN_LIC_ISSUE_DATE` has 507 (100.0%) missing values	Missing
`CIN_LIC_NO` has 507 (100.0%) missing values	Missing
`CIN_NAME_SHORT` has 227 (44.8%) missing values	Missing
`CIN_ID` has unique values	Unique
`TIMESTAMP` has unique values	Unique
`CIN_GRP_ID` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`CIN_GRP_CODE` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`CIN_LIC_ISSUE_DATE` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`CIN_LIC_NO` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2025-12-18 06:28:20.416855
Analysis finished	2025-12-18 06:28:22.271781
Duration	1.85 second
Software version	ydata-profiling vv4.18.0
Download configuration	config.json

HEAD_OFFICE_ID
Categorical

Constant

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	4.1 KiB

2	507

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	507
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
2	507	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	507	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	507	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	507	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	507	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	507	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	507	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	507	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	507	100.0%

REC_TYPE
Categorical

Constant Missing

Distinct	1
Distinct (%)	0.4%
Missing	280
Missing (%)	55.2%
Memory size	4.1 KiB

U	227

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	227
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	U
2nd row	U
3rd row	U
4th row	U
5th row	U

Common Values

Value	Count	Frequency (%)
U	227	44.8%
(Missing)	280	55.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
u	227	100.0%

Most occurring characters

Value	Count	Frequency (%)
U	227	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	227	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	227	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	227	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	227	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	227	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	227	100.0%

SRC_DB_ID
Real number (ℝ)

High correlation

Distinct	95
Distinct (%)	18.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	90.280079

Minimum	3
Maximum	1102
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	3
5-th percentile	4
Q1	4
median	4
Q3	68
95-th percentile	1074.7
Maximum	1102
Range	1099
Interquartile range (IQR)	64

Descriptive statistics

Standard deviation	255.64568
Coefficient of variation (CV)	2.8316954
Kurtosis	11.215068
Mean	90.280079
Median Absolute Deviation (MAD)	0
Skewness	3.6023158
Sum	45772
Variance	65354.716
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	280	55.2%
68	125	24.7%
38	2	0.4%
17	2	0.4%
16	2	0.4%
64	2	0.4%
15	2	0.4%
44	2	0.4%
66	2	0.4%
11	2	0.4%
Other values (85)	86	17.0%

Value	Count	Frequency (%)
3	1	0.2%
4	280	55.2%
5	1	0.2%
6	1	0.2%
7	1	0.2%
8	1	0.2%
9	1	0.2%
10	1	0.2%
11	2	0.4%
12	1	0.2%

Value	Count	Frequency (%)
1102	1	0.2%
1100	1	0.2%
1099	1	0.2%
1097	1	0.2%
1096	1	0.2%
1095	1	0.2%
1094	1	0.2%
1093	1	0.2%
1092	1	0.2%
1091	1	0.2%

SRC_TYPE_ID
Categorical

High correlation

Distinct	3
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	4.1 KiB

1	280
3	125
2	102

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	507
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	280	55.2%
3	125	24.7%
2	102	20.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	280	55.2%
3	125	24.7%
2	102	20.1%

Most occurring characters

Value	Count	Frequency (%)
1	280	55.2%
3	125	24.7%
2	102	20.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	507	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	280	55.2%
3	125	24.7%
2	102	20.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	507	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	280	55.2%
3	125	24.7%
2	102	20.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	507	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	280	55.2%
3	125	24.7%
2	102	20.1%

CIN_ID
Real number (ℝ)

High correlation Unique

Distinct	507
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4477.8777

Minimum	3
Maximum	10803
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 KiB

Quantile statistics

Minimum	3
5-th percentile	28.3
Q1	129.5
median	262
Q3	10670.5
95-th percentile	10771.7
Maximum	10803
Range	10800
Interquartile range (IQR)	10541

Descriptive statistics

Standard deviation	5190.1118
Coefficient of variation (CV)	1.1590562
Kurtosis	-1.8727723
Mean	4477.8777
Median Absolute Deviation (MAD)	214
Skewness	0.36562828
Sum	2270284
Variance	26937260
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	1	0.2%
7	1	0.2%
11	1	0.2%
15	1	0.2%
19	1	0.2%
23	1	0.2%
27	1	0.2%
31	1	0.2%
35	1	0.2%
39	1	0.2%
Other values (497)	497	98.0%

Value	Count	Frequency (%)
3	1	0.2%
4	1	0.2%
5	1	0.2%
6	1	0.2%
7	1	0.2%
8	1	0.2%
9	1	0.2%
10	1	0.2%
11	1	0.2%
12	1	0.2%

Value	Count	Frequency (%)
10803	1	0.2%
10801	1	0.2%
10800	1	0.2%
10799	1	0.2%
10798	1	0.2%
10797	1	0.2%
10795	1	0.2%
10794	1	0.2%
10793	1	0.2%
10791	1	0.2%

CIN_EXT_SALES_ID
Categorical

Constant Missing

Distinct	1
Distinct (%)	0.4%
Missing	227
Missing (%)	44.8%
Memory size	4.1 KiB

	280

Length

Max length	0
Median length	0
Mean length	0
Min length	0

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	280	55.2%
(Missing)	227	44.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

CIN_GRP_ID
Unsupported

Missing Rejected Unsupported

Missing	507
Missing (%)	100.0%
Memory size	4.1 KiB

CIN_STATUS_CODE
Categorical

High correlation Imbalance Missing

Distinct	2
Distinct (%)	0.7%
Missing	227
Missing (%)	44.8%
Memory size	4.1 KiB

A	251
I	29

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	280
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	I
5th row	A

Common Values

Value	Count	Frequency (%)
A	251	49.5%
I	29	5.7%
(Missing)	227	44.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	251	89.6%
i	29	10.4%

Most occurring characters

Value	Count	Frequency (%)
A	251	89.6%
I	29	10.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	280	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	251	89.6%
I	29	10.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	280	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	251	89.6%
I	29	10.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	280	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	251	89.6%
I	29	10.4%

CIN_TYPE_ID
Real number (ℝ)

High correlation Missing

Distinct	13
Distinct (%)	4.6%
Missing	227
Missing (%)	44.8%
Infinite	0
Infinite (%)	0.0%
Mean	5.3964286

Minimum	1
Maximum	15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	6
Q3	10
95-th percentile	11
Maximum	15
Range	14
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	4.1135306
Coefficient of variation (CV)	0.76226908
Kurtosis	-1.2419639
Mean	5.3964286
Median Absolute Deviation (MAD)	5
Skewness	0.32233088
Sum	1511
Variance	16.921134
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
1	105	20.7%
6	52	10.3%
11	46	9.1%
7	28	5.5%
10	13	2.6%
5	7	1.4%
2	7	1.4%
8	5	1.0%
3	5	1.0%
12	4	0.8%
Other values (3)	8	1.6%
(Missing)	227	44.8%

Value	Count	Frequency (%)
1	105	20.7%
2	7	1.4%
3	5	1.0%
5	7	1.4%
6	52	10.3%
7	28	5.5%
8	5	1.0%
10	13	2.6%
11	46	9.1%
12	4	0.8%

Value	Count	Frequency (%)
15	1	0.2%
14	4	0.8%
13	3	0.6%
12	4	0.8%
11	46	9.1%
10	13	2.6%
8	5	1.0%
7	28	5.5%
6	52	10.3%
5	7	1.4%

CCT_ID
Categorical

High correlation Imbalance Missing

Distinct	5
Distinct (%)	1.8%
Missing	227
Missing (%)	44.8%
Memory size	4.1 KiB

177.0	235
178.0	35
1178.0	7
1179.0	2
1180.0	1

Length

Max length	6
Median length	5
Mean length	5.0357143
Min length	5

Characters and Unicode

Total characters	1410
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.4%

Sample

1st row	1180.0
2nd row	177.0
3rd row	177.0
4th row	177.0
5th row	177.0

Common Values

Value	Count	Frequency (%)
177.0	235	46.4%
178.0	35	6.9%
1178.0	7	1.4%
1179.0	2	0.4%
1180.0	1	0.2%
(Missing)	227	44.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
177.0	235	83.9%
178.0	35	12.5%
1178.0	7	2.5%
1179.0	2	0.7%
1180.0	1	0.4%

Most occurring characters

Value	Count	Frequency (%)
7	514	36.5%
1	290	20.6%
0	281	19.9%
.	280	19.9%
8	43	3.0%
9	2	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1410	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
7	514	36.5%
1	290	20.6%
0	281	19.9%
.	280	19.9%
8	43	3.0%
9	2	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1410	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
7	514	36.5%
1	290	20.6%
0	281	19.9%
.	280	19.9%
8	43	3.0%
9	2	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1410	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
7	514	36.5%
1	290	20.6%
0	281	19.9%
.	280	19.9%
8	43	3.0%
9	2	0.1%

CRNCY_ID
Categorical

Constant Missing

Distinct	1
Distinct (%)	0.4%
Missing	227
Missing (%)	44.8%
Memory size	4.1 KiB

1.0	280

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	840
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	280	55.2%
(Missing)	227	44.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	280	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	280	33.3%
.	280	33.3%
0	280	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	840	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	280	33.3%
.	280	33.3%
0	280	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	840	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	280	33.3%
.	280	33.3%
0	280	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	840	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	280	33.3%
.	280	33.3%
0	280	33.3%

SITE_ID
Real number (ℝ)

High correlation Missing

Distinct	105
Distinct (%)	37.5%
Missing	227
Missing (%)	44.8%
Infinite	0
Infinite (%)	0.0%
Mean	204.83571

Minimum	2
Maximum	7318
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 KiB

Quantile statistics

Minimum	2
5-th percentile	8
Q1	21.75
median	47.5
Q3	76
95-th percentile	101
Maximum	7318
Range	7316
Interquartile range (IQR)	54.25

Descriptive statistics

Standard deviation	1054.0644
Coefficient of variation (CV)	5.1459013
Kurtosis	42.387921
Mean	204.83571
Median Absolute Deviation (MAD)	26.5
Skewness	6.6366174
Sum	57354
Variance	1111051.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	8	1.6%
69	8	1.6%
16	8	1.6%
80	7	1.4%
22	7	1.4%
59	7	1.4%
23	6	1.2%
21	6	1.2%
15	6	1.2%
41	5	1.0%
Other values (95)	212	41.8%
(Missing)	227	44.8%

Value	Count	Frequency (%)
2	2	0.4%
3	2	0.4%
4	5	1.0%
5	1	0.2%
6	1	0.2%
7	2	0.4%
8	3	0.6%
9	4	0.8%
10	2	0.4%
11	5	1.0%

Value	Count	Frequency (%)
7318	1	0.2%
7317	2	0.4%
7307	3	0.6%
124	3	0.6%
123	2	0.4%
101	5	1.0%
100	1	0.2%
99	5	1.0%
98	3	0.6%
97	3	0.6%

CINEMA
Text

Missing

Distinct	280
Distinct (%)	100.0%
Missing	227
Missing (%)	44.8%
Memory size	4.1 KiB

Length

Max length	30
Median length	23
Mean length	16.171429
Min length	5

Characters and Unicode

Total characters	4528
Distinct characters	56
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	280 ?
Unique (%)	100.0%

Sample

1st row	State Theatre
2nd row	George Street Cafe Bar
3rd row	Parramatta Gold Class
4th row	zInactive-Newcastle
5th row	Hornsby

Value	Count	Frequency (%)
delivery	54	9.0%
vmax	46	7.7%
gold	27	4.5%
class	27	4.5%
cafe	13	2.2%
bar	13	2.2%
street	11	1.8%
city	10	1.7%
north	8	1.3%
innaloo	8	1.3%
Other values (142)	380	63.7%

Most occurring characters

Value	Count	Frequency (%)
a	427	9.4%
e	409	9.0%
	317	7.0%
l	283	6.2%
o	275	6.1%
r	269	5.9%
i	261	5.8%
n	222	4.9%
t	209	4.6%
s	138	3.0%
Other values (46)	1718	37.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4528	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	427	9.4%
e	409	9.0%
	317	7.0%
l	283	6.2%
o	275	6.1%
r	269	5.9%
i	261	5.8%
n	222	4.9%
t	209	4.6%
s	138	3.0%
Other values (46)	1718	37.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4528	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	427	9.4%
e	409	9.0%
	317	7.0%
l	283	6.2%
o	275	6.1%
r	269	5.9%
i	261	5.8%
n	222	4.9%
t	209	4.6%
s	138	3.0%
Other values (46)	1718	37.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4528	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	427	9.4%
e	409	9.0%
	317	7.0%
l	283	6.2%
o	275	6.1%
r	269	5.9%
i	261	5.8%
n	222	4.9%
t	209	4.6%
s	138	3.0%
Other values (46)	1718	37.9%

CIN_ACCT_CODE
Categorical

High correlation Imbalance Missing

Distinct	38
Distinct (%)	13.6%
Missing	227
Missing (%)	44.8%
Memory size	4.1 KiB

	243
712915	1
718923	1
720920	1
724915	1
Other values (33)	33

Length

Max length	6
Median length	0
Mean length	0.79285714
Min length	0

Characters and Unicode

Total characters	222
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	37 ?
Unique (%)	13.2%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	243	47.9%
712915	1	0.2%
718923	1	0.2%
720920	1	0.2%
724915	1	0.2%
716915	1	0.2%
733915	1	0.2%
726915	1	0.2%
710920	1	0.2%
735913	1	0.2%
Other values (28)	28	5.5%
(Missing)	227	44.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
712915	1	2.7%
718923	1	2.7%
720920	1	2.7%
724915	1	2.7%
716915	1	2.7%
733915	1	2.7%
726915	1	2.7%
710920	1	2.7%
735913	1	2.7%
719923	1	2.7%
Other values (27)	27	73.0%

Most occurring characters

Value	Count	Frequency (%)
1	49	22.1%
9	41	18.5%
7	39	17.6%
5	32	14.4%
2	23	10.4%
3	14	6.3%
0	12	5.4%
6	5	2.3%
8	4	1.8%
4	3	1.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	222	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	49	22.1%
9	41	18.5%
7	39	17.6%
5	32	14.4%
2	23	10.4%
3	14	6.3%
0	12	5.4%
6	5	2.3%
8	4	1.8%
4	3	1.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	222	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	49	22.1%
9	41	18.5%
7	39	17.6%
5	32	14.4%
2	23	10.4%
3	14	6.3%
0	12	5.4%
6	5	2.3%
8	4	1.8%
4	3	1.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	222	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	49	22.1%
9	41	18.5%
7	39	17.6%
5	32	14.4%
2	23	10.4%
3	14	6.3%
0	12	5.4%
6	5	2.3%
8	4	1.8%
4	3	1.4%

CIN_CODE
Text

Missing

Distinct	407
Distinct (%)	81.2%
Missing	6
Missing (%)	1.2%
Memory size	4.1 KiB

Length

Max length	13
Median length	6
Mean length	6.0219561
Min length	2

Characters and Unicode

Total characters	3017
Distinct characters	30
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	404 ?
Unique (%)	80.6%

Sample

1st row	102370
2nd row	104918
3rd row	107917
4th row	111915
5th row	117915

Value	Count	Frequency (%)
99	93	18.3%
gtscin	5	1.0%
maqrie	3	0.6%
gc	3	0.6%
n'maqrie	2	0.4%
cg	2	0.4%
474915	2	0.4%
138917	2	0.4%
102370	1	0.2%
n'411915	1	0.2%
Other values (395)	395	77.6%

Most occurring characters

Value	Count	Frequency (%)
9	649	21.5%
1	477	15.8%
2	293	9.7%
4	271	9.0%
5	236	7.8%
'	228	7.6%
0	197	6.5%
7	191	6.3%
3	141	4.7%
n	117	3.9%
Other values (20)	217	7.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3017	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	649	21.5%
1	477	15.8%
2	293	9.7%
4	271	9.0%
5	236	7.8%
'	228	7.6%
0	197	6.5%
7	191	6.3%
3	141	4.7%
n	117	3.9%
Other values (20)	217	7.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3017	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	649	21.5%
1	477	15.8%
2	293	9.7%
4	271	9.0%
5	236	7.8%
'	228	7.6%
0	197	6.5%
7	191	6.3%
3	141	4.7%
n	117	3.9%
Other values (20)	217	7.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3017	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	649	21.5%
1	477	15.8%
2	293	9.7%
4	271	9.0%
5	236	7.8%
'	228	7.6%
0	197	6.5%
7	191	6.3%
3	141	4.7%
n	117	3.9%
Other values (20)	217	7.2%

CIN_CRNCY
Categorical

Constant Missing

Distinct	1
Distinct (%)	0.4%
Missing	227
Missing (%)	44.8%
Memory size	4.1 KiB

1	280

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	280
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	280	55.2%
(Missing)	227	44.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	280	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	280	100.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	280	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	280	100.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	280	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	280	100.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	280	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	280	100.0%

CIN_CRCY_REG
Categorical

Constant Missing

Distinct	1
Distinct (%)	0.4%
Missing	227
Missing (%)	44.8%
Memory size	4.1 KiB

	280

Length

Max length	0
Median length	0
Mean length	0
Min length	0

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	280	55.2%
(Missing)	227	44.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

CIN_EMAIL
Categorical

Constant Missing

Distinct	1
Distinct (%)	0.7%
Missing	363
Missing (%)	71.6%
Memory size	4.1 KiB

	144

Length

Max length	0
Median length	0
Mean length	0
Min length	0

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row
3rd row
4th row
5th row

Common Values

Value	Count	Frequency (%)
	144	28.4%
(Missing)	363	71.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

CIN_GL_CODE
Real number (ℝ)

High correlation Missing

Distinct	15
Distinct (%)	5.4%
Missing	227
Missing (%)	44.8%
Infinite	0
Infinite (%)	0.0%
Mean	915.79643

Minimum	370
Maximum	927
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.1 KiB

Quantile statistics

Minimum	370
5-th percentile	915
Q1	915
median	917
Q3	920.25
95-th percentile	922
Maximum	927
Range	557
Interquartile range (IQR)	5.25

Descriptive statistics

Standard deviation	32.881856
Coefficient of variation (CV)	0.035905203
Kurtosis	274.96048
Mean	915.79643
Median Absolute Deviation (MAD)	2
Skewness	-16.507026
Sum	256423
Variance	1081.2165
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
915	104	20.5%
922	56	11.0%
918	47	9.3%
917	26	5.1%
919	13	2.6%
914	7	1.4%
923	5	1.0%
913	5	1.0%
916	4	0.8%
926	4	0.8%
Other values (5)	9	1.8%
(Missing)	227	44.8%

Value	Count	Frequency (%)
370	1	0.2%
913	5	1.0%
914	7	1.4%
915	104	20.5%
916	4	0.8%
917	26	5.1%
918	47	9.3%
919	13	2.6%
920	3	0.6%
921	1	0.2%

Value	Count	Frequency (%)
927	1	0.2%
926	4	0.8%
924	3	0.6%
923	5	1.0%
922	56	11.0%
921	1	0.2%
920	3	0.6%
919	13	2.6%
918	47	9.3%
917	26	5.1%

CIN_GRP_CODE
Unsupported

Missing Rejected Unsupported

Missing	507
Missing (%)	100.0%
Memory size	4.1 KiB

CIN_GST_CODE
Categorical

High correlation Missing

Distinct	14
Distinct (%)	5.0%
Missing	227
Missing (%)	44.8%
Memory size	4.1 KiB

ABN: 33 595 052 153	84
ABN:	70
ABN: 40 009 659 643	54
ABN: 99 000 024 439	23
ABN: 11 913 370 633	17
Other values (9)	32

Length

Max length	19
Median length	19
Mean length	15.210714
Min length	4

Characters and Unicode

Total characters	4259
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.4%

Sample

1st row	ABN:
2nd row	ABN: 99 000 024 439
3rd row	ABN: 33 595 052 153
4th row	ABN: 99 000 024 439
5th row	ABN: 11 913 370 633

Common Values

Value	Count	Frequency (%)
ABN: 33 595 052 153	84	16.6%
ABN:	70	13.8%
ABN: 40 009 659 643	54	10.7%
ABN: 99 000 024 439	23	4.5%
ABN: 11 913 370 633	17	3.4%
ABN: 25 221 284 744	6	1.2%
ABN: 75 934 743 451	6	1.2%
ABN: 16 588 912 255	5	1.0%
ABN: 19 018 690 039	4	0.8%
ABN: 92 630 664 979	3	0.6%
Other values (4)	8	1.6%
(Missing)	227	44.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
abn	279	25.0%
33	84	7.5%
595	84	7.5%
052	84	7.5%
153	84	7.5%
40	54	4.8%
009	54	4.8%
659	54	4.8%
643	54	4.8%
99	23	2.1%
Other values (39)	260	23.3%

Most occurring characters

Value	Count	Frequency (%)
	834	19.6%
3	431	10.1%
5	426	10.0%
0	385	9.0%
9	321	7.5%
:	279	6.6%
B	279	6.6%
N	279	6.6%
A	279	6.6%
4	193	4.5%
Other values (6)	553	13.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4259	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	834	19.6%
3	431	10.1%
5	426	10.0%
0	385	9.0%
9	321	7.5%
:	279	6.6%
B	279	6.6%
N	279	6.6%
A	279	6.6%
4	193	4.5%
Other values (6)	553	13.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4259	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	834	19.6%
3	431	10.1%
5	426	10.0%
0	385	9.0%
9	321	7.5%
:	279	6.6%
B	279	6.6%
N	279	6.6%
A	279	6.6%
4	193	4.5%
Other values (6)	553	13.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4259	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	834	19.6%
3	431	10.1%
5	426	10.0%
0	385	9.0%
9	321	7.5%
:	279	6.6%
B	279	6.6%
N	279	6.6%
A	279	6.6%
4	193	4.5%
Other values (6)	553	13.0%

CIN_HO_CODE
Text

Missing

Distinct	405
Distinct (%)	100.0%
Missing	102
Missing (%)	20.1%
Memory size	4.1 KiB

Length

Max length	13
Median length	6
Mean length	6.9333333
Min length	4

Characters and Unicode

Total characters	2808
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	405 ?
Unique (%)	100.0%

Sample

1st row	102370
2nd row	104918
3rd row	107917
4th row	111915
5th row	117915

Value	Count	Frequency (%)
gtscin	4	1.0%
gc	3	0.7%
maqrie	3	0.7%
n'maqrie	2	0.5%
107917	1	0.2%
n'428915	1	0.2%
117915	1	0.2%
124915	1	0.2%
125920	1	0.2%
n'433915	1	0.2%
Other values (394)	394	95.6%

Most occurring characters

Value	Count	Frequency (%)
1	471	16.8%
9	459	16.3%
2	292	10.4%
4	269	9.6%
5	231	8.2%
'	228	8.1%
0	197	7.0%
7	188	6.7%
3	140	5.0%
N	119	4.2%
Other values (17)	214	7.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2808	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	471	16.8%
9	459	16.3%
2	292	10.4%
4	269	9.6%
5	231	8.2%
'	228	8.1%
0	197	7.0%
7	188	6.7%
3	140	5.0%
N	119	4.2%
Other values (17)	214	7.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2808	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	471	16.8%
9	459	16.3%
2	292	10.4%
4	269	9.6%
5	231	8.2%
'	228	8.1%
0	197	7.0%
7	188	6.7%
3	140	5.0%
N	119	4.2%
Other values (17)	214	7.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2808	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	471	16.8%
9	459	16.3%
2	292	10.4%
4	269	9.6%
5	231	8.2%
'	228	8.1%
0	197	7.0%
7	188	6.7%
3	140	5.0%
N	119	4.2%
Other values (17)	214	7.6%

CIN_IS_ACTV
Boolean

High correlation Missing

Distinct	2
Distinct (%)	0.6%
Missing	166
Missing (%)	32.7%
Memory size	4.1 KiB

True	251
False	90
(Missing)	166

Value	Count	Frequency (%)
True	251	49.5%
False	90	17.8%
(Missing)	166	32.7%

CIN_IS_DEL
Boolean

Constant Missing

Distinct	1
Distinct (%)	0.3%
Missing	166
Missing (%)	32.7%
Memory size	4.1 KiB

False	341
(Missing)	166

Value	Count	Frequency (%)
False	341	67.3%
(Missing)	166	32.7%

CIN_LIC_ISSUE_DATE
Unsupported

Missing Rejected Unsupported

Missing	507
Missing (%)	100.0%
Memory size	4.1 KiB

CIN_LIC_NO
Unsupported

Missing Rejected Unsupported

Missing	507
Missing (%)	100.0%
Memory size	4.1 KiB

CIN_NAME_SHORT
Text

Missing

Distinct	279
Distinct (%)	99.6%
Missing	227
Missing (%)	44.8%
Memory size	4.1 KiB

Length

Max length	9
Median length	9
Mean length	7.875
Min length	6

Characters and Unicode

Total characters	2205
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	278 ?
Unique (%)	99.3%

Sample

1st row	STATET
2nd row	GEORGE BS
3rd row	PMATTA GC
4th row	NEWCAS
5th row	HORNSB

Value	Count	Frequency (%)
ct	56	12.3%
vm	46	10.1%
gc	27	5.9%
bs	12	2.6%
george	8	1.8%
cherms	8	1.8%
inaloo	8	1.8%
macart	7	1.5%
loganh	7	1.5%
pacfar	7	1.5%
Other values (111)	269	59.1%

Most occurring characters

Value	Count	Frequency (%)
A	197	8.9%
	175	7.9%
C	172	7.8%
T	165	7.5%
R	149	6.8%
N	145	6.6%
M	143	6.5%
O	132	6.0%
E	105	4.8%
S	102	4.6%
Other values (17)	720	32.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2205	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	197	8.9%
	175	7.9%
C	172	7.8%
T	165	7.5%
R	149	6.8%
N	145	6.6%
M	143	6.5%
O	132	6.0%
E	105	4.8%
S	102	4.6%
Other values (17)	720	32.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2205	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	197	8.9%
	175	7.9%
C	172	7.8%
T	165	7.5%
R	149	6.8%
N	145	6.6%
M	143	6.5%
O	132	6.0%
E	105	4.8%
S	102	4.6%
Other values (17)	720	32.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2205	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	197	8.9%
	175	7.9%
C	172	7.8%
T	165	7.5%
R	149	6.8%
N	145	6.6%
M	143	6.5%
O	132	6.0%
E	105	4.8%
S	102	4.6%
Other values (17)	720	32.7%

TIMESTAMP
Text

Unique

Distinct	507
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	4.1 KiB

Length

Max length	18
Median length	18
Mean length	18
Min length	18

Characters and Unicode

Total characters	9126
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	507 ?
Unique (%)	100.0%

Sample

1st row	0x00000007A0BFE21A
2nd row	0x00000007A0031758
3rd row	0x0000000779D05A91
4th row	0x0000000629B9F537
5th row	0x00000006DAF9F47E

Value	Count	Frequency (%)
0x00000007a0bfe21a	1	0.2%
0x00000007a0031758	1	0.2%
0x0000000779d05a91	1	0.2%
0x0000000629b9f537	1	0.2%
0x00000006daf9f47e	1	0.2%
0x00000007f7c5db84	1	0.2%
0x0000000779d05a98	1	0.2%
0x00000006156d9b95	1	0.2%
0x00000006156d9b9a	1	0.2%
0x0000000779d05a9a	1	0.2%
Other values (497)	497	98.0%

Most occurring characters

Value	Count	Frequency (%)
0	4396	48.2%
7	577	6.3%
x	507	5.6%
6	502	5.5%
D	465	5.1%
1	348	3.8%
5	314	3.4%
B	290	3.2%
9	285	3.1%
F	280	3.1%
Other values (7)	1162	12.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9126	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	4396	48.2%
7	577	6.3%
x	507	5.6%
6	502	5.5%
D	465	5.1%
1	348	3.8%
5	314	3.4%
B	290	3.2%
9	285	3.1%
F	280	3.1%
Other values (7)	1162	12.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9126	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	4396	48.2%
7	577	6.3%
x	507	5.6%
6	502	5.5%
D	465	5.1%
1	348	3.8%
5	314	3.4%
B	290	3.2%
9	285	3.1%
F	280	3.1%
Other values (7)	1162	12.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9126	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	4396	48.2%
7	577	6.3%
x	507	5.6%
6	502	5.5%
D	465	5.1%
1	348	3.8%
5	314	3.4%
B	290	3.2%
9	285	3.1%
F	280	3.1%
Other values (7)	1162	12.7%

Interactions

Correlations

	CCT_ID	CIN_ACCT_CODE	CIN_GL_CODE	CIN_GST_CODE	CIN_ID	CIN_IS_ACTV	CIN_STATUS_CODE	CIN_TYPE_ID	SITE_ID	SRC_DB_ID	SRC_TYPE_ID
CCT_ID	1.000	0.597	0.502	0.303	0.000	0.000	0.000	0.063	0.000	1.000	1.000
CIN_ACCT_CODE	0.597	1.000	0.000	0.000	0.000	0.000	0.000	0.102	0.183	1.000	1.000
CIN_GL_CODE	0.502	0.000	1.000	0.000	0.320	0.313	0.313	0.582	-0.071	NaN	1.000
CIN_GST_CODE	0.303	0.000	0.000	1.000	0.034	0.130	0.130	0.000	0.138	1.000	1.000
CIN_ID	0.000	0.000	0.320	0.034	1.000	0.176	0.034	0.129	0.214	0.629	0.703
CIN_IS_ACTV	0.000	0.000	0.313	0.130	0.176	1.000	0.981	0.000	0.000	1.000	0.770
CIN_STATUS_CODE	0.000	0.000	0.313	0.130	0.034	0.981	1.000	0.000	0.000	1.000	1.000
CIN_TYPE_ID	0.063	0.102	0.582	0.000	0.129	0.000	0.000	1.000	-0.044	NaN	1.000
SITE_ID	0.000	0.183	-0.071	0.138	0.214	0.000	0.000	-0.044	1.000	NaN	1.000
SRC_DB_ID	1.000	1.000	NaN	1.000	0.629	1.000	1.000	NaN	NaN	1.000	0.505
SRC_TYPE_ID	1.000	1.000	1.000	1.000	0.703	0.770	1.000	1.000	1.000	0.505	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	HEAD_OFFICE_ID	REC_TYPE	SRC_DB_ID	SRC_TYPE_ID	CIN_ID	CIN_GRP_ID	CIN_STATUS_CODE	CIN_TYPE_ID	CCT_ID	CRNCY_ID	SITE_ID	CINEMA	CIN_CODE	CIN_CRNCY	CIN_EMAIL	CIN_GL_CODE	CIN_GRP_CODE	CIN_GST_CODE	CIN_HO_CODE	CIN_IS_ACTV	CIN_IS_DEL	CIN_LIC_ISSUE_DATE	CIN_LIC_NO	CIN_NAME_SHORT	TIMESTAMP
0	2	None	4	1	3	NaN	A	1.0	1180.0	1.0	96.0	State Theatre	102370	1	None	370	None	ABN:	102370	True	False	None	None	STATET	0x00000007A0BFE21A
1	2	None	4	1	7	NaN	A	10.0	177.0	1.0	14.0	George Street Cafe Bar	104918	1		919	None	ABN: 99 000 024 439	104918	True	False	None	None	GEORGE BS	0x00000007A0031758
2	2	None	4	1	11	NaN	A	7.0	177.0	1.0	58.0	Parramatta Gold Class	107917	1		917	None	ABN: 33 595 052 153	107917	True	False	None	None	PMATTA GC	0x0000000779D05A91
3	2	None	4	1	15	NaN	I	1.0	177.0	1.0	91.0	zInactive-Newcastle	111915	1		915	None	ABN: 99 000 024 439	111915	False	False	None	None	NEWCAS	0x0000000629B9F537
4	2	None	4	1	19	NaN	A	1.0	177.0	1.0	18.0	Hornsby	117915	1		915	None	ABN: 11 913 370 633	117915	True	False	None	None	HORNSB	0x00000006DAF9F47E
5	2	None	4	1	23	NaN	A	1.0	177.0	1.0	53.0	Blacktown	124915	1		915	None	ABN: 99 000 024 439	124915	True	False	None	None	BLKTWN	0x00000007F7C5DB84
6	2	None	4	1	27	NaN	A	11.0	177.0	1.0	89.0	Kotara Vmax	125920	1	None	918	None	ABN: 99 000 024 439	125920	True	False	None	None	KOTARA VM	0x0000000779D05A98
7	2	None	4	1	31	NaN	A	7.0	177.0	1.0	11.0	Bondi Junction Gold Class	132917	1		917	None	ABN: 33 595 052 153	132917	True	False	None	None	BONDIJ GC	0x00000006156D9B95
8	2	None	4	1	35	NaN	A	7.0	177.0	1.0	21.0	Castle Hill Gold Class	133917	1		917	None	ABN: 25 221 284 744	133917	True	False	None	None	CASTLE GC	0x00000006156D9B9A
9	2	None	4	1	39	NaN	A	11.0	177.0	1.0	19.0	Burwood Vmax	134920	1		918	None	ABN: 11 913 370 633	134920	True	False	None	None	BURWOD VM	0x0000000779D05A9A

	HEAD_OFFICE_ID	REC_TYPE	SRC_DB_ID	SRC_TYPE_ID	CIN_ID	CIN_EXT_SALES_ID	CIN_GRP_ID	CIN_STATUS_CODE	CIN_TYPE_ID	CCT_ID	CRNCY_ID	SITE_ID	CINEMA	CIN_ACCT_CODE	CIN_CODE	CIN_CRNCY	CIN_CRCY_REG	CIN_EMAIL	CIN_GL_CODE	CIN_GRP_CODE	CIN_GST_CODE	CIN_HO_CODE	CIN_IS_ACTV	CIN_IS_DEL	CIN_LIC_ISSUE_DATE	CIN_LIC_NO	CIN_NAME_SHORT	TIMESTAMP
497	2	U	38	2	10760	None	NaN	None	NaN	NaN	NaN	NaN	None	None	None	None	None	None	None	None	None	None	None	None	None	None	None	0x000000051251CE85
498	2	None	4	1	10764		NaN	A	6.0	177.0	1.0	7307.0	Ed Square Delivery		127922	1		None	922	None	ABN:	127922	True	False	None	None	EDPARK CT	0x0000000779D05B23
499	2	None	4	1	10768		NaN	A	6.0	177.0	1.0	97.0	Palmerston Delivery		483922	1		None	922	None	ABN: 33 595 052 153	483922	True	False	None	None	PALMNT CT	0x0000000779D05B25
500	2	None	4	1	10772		NaN	A	11.0	178.0	1.0	75.0	Queensgate Vmax	719918	719920	1		None	918	None	ABN:	719920	True	False	None	None	QSGATE VM	0x0000000779D05B29
501	2	None	4	1	10776		NaN	A	13.0	177.0	1.0	40.0	Strathpine Recline		470924	1		None	924	None	ABN: 75 934 743 451	470924	True	False	None	None	STRPNE RC	0x0000000779D05B2C
502	2	None	4	1	10780		NaN	A	14.0	177.0	1.0	23.0	Robina SCREENX		407926	1		None	926	None	ABN: 40 009 659 643	407926	True	False	None	None	ROBINA SX	0x00000007D82F1BC3
503	2	None	4	1	10785		NaN	A	10.0	177.0	1.0	7317.0	IMAX Sydney Cafe Bar		120918	1		None	919	None	ABN:	120918	True	False	None	None	IMAXSY BS	0x0000000779D05B2F
504	2	None	4	1	10791		NaN	A	3.0	177.0	1.0	22.0	Pacific Fair IMAX	405923	405923	1		None	923	None	ABN: 40 009 659 643	405923	True	False	None	None	PACFAR IM	0x00000007D810F1C1
505	2	None	4	1	10797		NaN	A	13.0	177.0	1.0	29.0	Rockhampton Recline		426924	1		None	924	None	ABN: 40 009 659 643	426924	True	False	None	None	ROCNTH RC	0x0000000779D05B33
506	2	None	4	1	10801		NaN	A	14.0	177.0	1.0	59.0	Loganholme SCREENX		450926	1		None	926	None	ABN: 130 80111 173	450926	True	False	None	None	LOGANH SX	0x00000007D82F1BC6

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)